﻿<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
    <title></title>
	<meta charset="utf-8" />
    <script src="../../../JS/jquery-1.11.1.min.js"></script>
    <link href="../../../css/bootstrap-4.3.1-dist/css/bootstrap.min.css" rel="stylesheet" />
    <script src="../../../css/bootstrap-4.3.1-dist/js/bootstrap.min.js"></script>

    <!--<script src="../../../EasyUI/jquery.min.js"></script>
    <script src="../../../EasyUI/jquery.easyui.min.js"></script>
    <link href="../../../css/easyUICSS/themes/icon.css" rel="stylesheet" />
    <link href="../../../css/easyUICSS/themes/color.css" rel="stylesheet" />
    <link href="../../../css/easyUICSS/themes/metro/easyui.css" rel="stylesheet" />-->
</head>
<body>
   <input id="btnSeach" type="button" value="查询"  class="btn btn-default"  /><br />
    <div style="overflow-x: auto; overflow-y: auto; height: 600px; width:1400px;">
        <div class="table-responsive">
            <table style="width:100%; font-size:12px;white-space: nowrap;" id="userlisttb" class="table table-striped table-bordered" overflow:auto><!--table table-hover--><!---->
                <tr >
                    <th>水表号</th>
                    <th>用户号</th>
                    <th>水表户名</th>
                    <th>册号</th>
                    <th>上月抄码</th>
                    <th>抄表日期</th>
                    <th>本月抄码</th>
                    <th>水量</th>
                    <th>抄表状态</th>
                    <th>水司状态</th>
                    <th>单价</th>
                    <th>表分类价</th>
                    <th>涉水对象代码</th>
                    <th>涉水对象名称</th>
                    <th>抄表周期</th>
                    <th>表地址</th>
                    <th>表分类</th>
                    <th>行政区</th>
                    <th>管网块号</th>
                    <th>口径</th>
                    <th>表型</th>
                    <th>装表日期</th>
                    <th>总表号</th>
                </tr>
            </table>
        </div>
        <div id="userlisttb" class="datagrid"></div>
    </div>
</body>
<script type="text/javascript">
   // event
    $("#btnSeach").click(function (event) {

        BindGv();

    })


    //$().ready(function () {
    
       

    //});
    //<a href="Handler1.ashx">Handler1.ashx</a>
    function BindGv() { 
        $.get('Handler1.ashx', { type: 'ShowWaterData' }, function (e) {
           
            $(e).each(function (i) {
                if (e[i].S_YONGHUH == null) {
                    e[i].S_YONGHUH="";
                }
                if (e[i].S_SHUIBIAOHM == null) {
                    e[i].S_SHUIBIAOHM = "";
                }
                if (e[i].S_CH == null) {
                    e[i].S_CH = "";
                }
                if (e[i].I_SHANGYUECM == null) {
                    e[i].I_SHANGYUECM = "";
                }
                if (e[i].S_SHESHUIDXFLMC == null) {
                    e[i].S_SHESHUIDXFLMC = "";
                }
                
                if (e[i].I_CHAOBIAOZQ == null) {
                    e[i].I_CHAOBIAOZQ = "";
                }
                
                if (e[i].S_BX == null) {
                    e[i].S_BX = "";
                }
                if (e[i].D_ZHUANGBIAORQ == null) {
                    e[i].D_ZHUANGBIAORQ = "";
                }
                if (e[i].S_ZBH == null) {
                    e[i].S_ZBH = "";
                }
             
                var tr = "<tr  id=\"" + e[i].ID + "\"> <td>" + e[i].S_SHUIBIAOBH + "</td><td>" + e[i].S_YONGHUH + "</td><td>" + e[i].S_SHUIBIAOHM + "</td><td>" +
                    e[i].S_CH + "</td><td>" + e[i].I_SHANGYUECM + "</td><td>" + e[i].D_CHAOBIAORQ + "</td><td>" + e[i].I_BENYUECM + "</td><td>" + e[i].I_YONGSHUIL +
                    "</td><td>" + e[i].CHAOBIAOZT + "</td><td>" + e[i].S_YUANCHAOBZT + "</td><td>" + e[i].N_YSJ + "</td><td>" + e[i].S_BFL + "</td> <td>" + e[i].S_SHESHUIDXFLDM +
                    "</td> <td>" + e[i].S_SHESHUIDXFLMC + "</td><td>" + e[i].I_CHAOBIAOZQ + "</td><td>" + e[i].S_SHUIBIAODZ + "</td><td>" + e[i].I_TYPE + "</td><td>" + e[i].S_MINGCHENG +
                    "</td><td>" + e[i].S_KUAIHAO + "</td><td>" + e[i].I_KOUJING + "</td><td>" + e[i].S_BX + "</td><td>" + e[i].D_ZHUANGBIAORQ + "</td><td>" + e[i].S_ZBH + "</td></tr>";
                $("table").append(tr);
            });
        }, "json");

    };
    
</script>
</html>
